#!/usr/bin/env python
# coding=utf-8
# __author__ = 'Yunchao Ling'

import xlwings as xw

# workbook=xlwings.Book(r'D:/data/BeautifulLulu/201809登记表.xls')

wb = xw.Book(r'D:\data\BeautifulLulu\201809登记表.xls')
sht=wb.sheets['麻醉登记']

aa=sht.range('E1').value
print(aa)


# count=0
# for item in sht.range('B:B').value:
#     if item!=None:
#         print(item)
#         count+=1
# print(count)